| transition_to_stage | transition_from_stage_name | opportunity_type | core_consumption_market | core_product_segment | core_sales_segment | geography | core_product_application | progression_time_days | remaining_deadline_days | decision_time_days | transition_time | early_stages | no_of_products | product_status | product_$ | product_quantity | target | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 301566 | 1.000000 | 1.000000 | 0.852629 | 0.746963 | 0.851281 | 0.711444 | 0.780303 | 0.751358 | 126.210000 | 0.790000 | 127.000000 | 2.000000 | 0.000000 | 1.000000 | 2.000000 | 24310.000000 | 1430.000000 | 1 |
| 35598 | 1.000000 | 1.000000 | 0.852629 | 0.872898 | 0.851281 | 0.865809 | 0.814970 | 0.878638 | 301.210000 | -273.210000 | 28.000000 | 5.000000 | 0.000000 | 2.000000 | 2.000000 | 6982.000000 | 62.000000 | 1 |
| 145284 | 1.000000 | 1.000000 | 0.852629 | 0.872898 | 0.851281 | 0.865809 | 0.852580 | 0.878638 | 147.880000 | -70.880000 | 77.000000 | 21.100000 | 0.000000 | 3.000000 | 2.000000 | 1143500.000000 | 5040.000000 | 1 |
| 11560 | -1.000000 | -1.000000 | 0.852629 | 0.751244 | 0.851281 | 0.650350 | 0.852580 | 0.634894 | 258.880000 | -163.880000 | 95.000000 | 7.670000 | 0.000000 | 1.000000 | 0.000000 | 22000.000000 | 1000.000000 | 0 |
| 144353 | 0.500000 | 0.500000 | 0.852629 | 0.916796 | 0.851281 | 0.865809 | 0.814970 | 0.890127 | 3.650000 | 95.350000 | 99.000000 | 2.770000 | 0.000000 | 1.000000 | 1.000000 | 960000.000000 | 5000.000000 | 1 |
| transition_to_stage | transition_from_stage_name | opportunity_type | core_consumption_market | core_product_segment | core_sales_segment | geography | core_product_application | progression_time_days | remaining_deadline_days | decision_time_days | transition_time | early_stages | no_of_products | product_status | product_$ | product_quantity | target | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 112369 | 0.250000 | 0.250000 | 0.852629 | 0.872898 | 0.851281 | 0.954583 | 0.852580 | 0.890127 | 273.210000 | -0.210000 | 273.000000 | 5.000000 | 0.000000 | 5.000000 | 0.000000 | 7992450.000000 | 54650.000000 | 1 |
| 246985 | 1.000000 | 0.250000 | 0.852629 | 0.848445 | 0.851281 | 0.865809 | 0.852580 | 0.890127 | 206.880000 | 3.120000 | 210.000000 | 2.670000 | 0.000000 | 2.000000 | 2.000000 | 215280.000000 | 1840.000000 | 1 |
| 227626 | 0.750000 | 0.750000 | 0.852629 | 0.793857 | 0.479953 | 0.865809 | 0.888289 | 0.523732 | 165.880000 | 134.120000 | 300.000000 | 7.670000 | 0.000000 | 1.000000 | 1.000000 | 120000.000000 | 10000.000000 | 0 |
| 232926 | 0.250000 | 0.250000 | 0.716273 | 0.872898 | 0.851281 | 0.733762 | 0.814970 | 0.878638 | 101.880000 | 44.120000 | 146.000000 | 21.100000 | 0.000000 | 1.000000 | 1.000000 | 2300000.000000 | 20000.000000 | 0 |
| 395851 | 0.750000 | 0.750000 | 0.852629 | 0.793857 | 0.851281 | 0.865809 | 0.780303 | 0.751358 | 95.210000 | 14.790000 | 110.000000 | 5.000000 | 0.000000 | 2.000000 | 1.000000 | 148000.000000 | 6000.000000 | 0 |
No missing values in data
No Infinity values
No Missing Values
No duplicate variables
| Data Shape:(63016, 18) | ||||||
|---|---|---|---|---|---|---|
| feature | < (mean-3*std) | > (mean+3*std) | < (1stQ - 1.5 * IQR) | > (3rdQ + 1.5 * IQR) | -inf | +inf |
| transition_to_stage | 4175 | 0 | 4175 | 0 | 0 | 0 |
| transition_from_stage_name | 3833 | 0 | 3833 | 0 | 0 | 0 |
| opportunity_type | 0 | 0 | 6383 | 0 | 0 | 0 |
| core_product_segment | 2581 | 0 | 3436 | 0 | 0 | 0 |
| core_sales_segment | 0 | 0 | 12256 | 2048 | 0 | 0 |
| core_product_application | 1151 | 0 | 2129 | 0 | 0 | 0 |
| remaining_deadline_days | 0 | 0 | 0 | 1160 | 0 | 0 |
| decision_time_days | 0 | 1095 | 0 | 3013 | 0 | 0 |
| transition_time | 0 | 0 | 0 | 8679 | 0 | 0 |
| no_of_products | 0 | 1824 | 0 | 4456 | 0 | 0 |
| product_$ | 0 | 1235 | 0 | 7973 | 0 | 0 |
| product_quantity | 0 | 1203 | 0 | 8776 | 0 | 0 |
| target | 0 | 0 | 10193 | 0 | 0 | 0 |
| Variable Name | Datatype | No of Unique | Samples | Mean | Standard Deviation | Min | 25th percentile | Median | 75th percentile | Max | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | core_consumption_market | float64 | 15 | [0.7469628175236225, 0.8728984751726835, 0.7512437810945274, 0.9167960260788575, 0.7764397905759163] | 0.839125 | 0.056488 | 0.684488 | 0.793857 | 0.872898 | 0.872898 | 0.948258 |
| 1 | core_product_application | float64 | 14 | [0.7513583837147012, 0.8786381285498829, 0.6348936170212766, 0.8901274477018541, 0.7398753894080997] | 0.841492 | 0.078514 | 0.592498 | 0.786777 | 0.878638 | 0.890127 | 0.890127 |
| 2 | core_product_segment | float64 | 3 | [0.8512808126350254, 0.6758375257740865, 0.7075471698113207] | 0.842145 | 0.038178 | 0.675838 | 0.851281 | 0.851281 | 0.851281 | 0.851281 |
| 3 | core_sales_segment | float64 | 8 | [0.7114444082164982, 0.8658086122830922, 0.6503496503496503, 0.7337618403247632, 0.7222222222222222] | 0.839856 | 0.063486 | 0.650350 | 0.865809 | 0.865809 | 0.865809 | 0.954583 |
| 4 | decision_time_days | float64 | 350 | [127.0, 28.0, 77.0, 95.0, 99.0] | 74.521604 | 81.255842 | -67.000000 | 16.000000 | 48.000000 | 112.000000 | 326.636000 |
| 5 | geography | float64 | 5 | [0.7803030303030303, 0.8149700598802395, 0.8525798525798526, 0.8882890365448505, 0.8068251066422912] | 0.838883 | 0.041464 | 0.780303 | 0.814970 | 0.814970 | 0.888289 | 0.888289 |
| 6 | no_of_products | float64 | 6 | [1.0, 2.0, 3.0, 4.0, 5.910565428078694] | 1.517470 | 1.122655 | 1.000000 | 1.000000 | 1.000000 | 2.000000 | 5.910565 |
| 7 | opportunity_type | float64 | 2 | [0.8526290536535802, 0.7162726008344924] | 0.838817 | 0.041141 | 0.716273 | 0.852629 | 0.852629 | 0.852629 | 0.852629 |
| 8 | product_$ | float64 | 2348 | [24310.0, 6982.0, 1143500.0, 22000.0, 960000.0] | 751691.751630 | 2134929.278371 | 0.000000 | 3375.000000 | 82500.000000 | 480000.000000 | 12957825.016772 |
| 9 | product_quantity | float64 | 1085 | [1430.0, 62.0, 5040.0, 1000.0, 5000.0] | 15483.914375 | 54179.190706 | 1.000000 | 41.000000 | 1000.000000 | 4080.000000 | 316028.560488 |
| 10 | product_status | float64 | 3 | [2.0, 0.0, 1.0] | 1.492177 | 0.647313 | 0.000000 | 1.000000 | 2.000000 | 2.000000 | 2.000000 |
| 11 | progression_time_days | float64 | 1272 | [126.21, 301.21, 147.88, 258.88, 3.65] | 122.525385 | 81.015433 | 0.540000 | 54.540000 | 111.210000 | 182.210000 | 309.210000 |
| 12 | remaining_deadline_days | float64 | 2130 | [0.79, -273.21, -70.88, -163.88, 95.35] | -47.983688 | 105.446988 | -291.210000 | -116.210000 | -39.210000 | 13.790000 | 265.740500 |
| 13 | transition_from_stage_name | float64 | 6 | [1.0, -0.9340748276274982, 0.5, 0.25, 0.75] | 0.642808 | 0.511846 | -0.934075 | 0.250000 | 1.000000 | 1.000000 | 1.000000 |
| 14 | transition_time | float64 | 394 | [2.0, 5.0, 21.1, 7.67, 2.77] | 9.275275 | 7.597414 | 0.420000 | 5.000000 | 5.000000 | 12.330000 | 26.330000 |
| 15 | transition_to_stage | float64 | 6 | [1.0, -0.9301181822615341, 0.5, 0.25, 0.75] | 0.667624 | 0.516627 | -0.930118 | 0.500000 | 1.000000 | 1.000000 | 1.000000 |
| Variable Name | Datatype | No of Unique | Samples | Mode | Mode Freq | Mode Freq % | |
|---|---|---|---|---|---|---|---|
| 0 | target | int32 | 2 | [1, 0] | 1 | 52823 | 83.824743 |
No categorical variables in data.
| Variable 1 | Variable 2 | Corr Coef | Abs Corr Coef | |
|---|---|---|---|---|
| 0 | transition_from_stage_name | transition_to_stage | 0.945873 | 0.945873 |
| 1 | product_status | transition_to_stage | 0.764927 | 0.764927 |
| 2 | product_status | transition_from_stage_name | 0.742777 | 0.742777 |
| 3 | product_$ | product_quantity | 0.686302 | 0.686302 |
| 4 | target | transition_to_stage | 0.661084 | 0.661084 |
| 5 | decision_time_days | remaining_deadline_days | 0.654523 | 0.654523 |
| 6 | target | transition_from_stage_name | 0.621211 | 0.621211 |
| 7 | progression_time_days | remaining_deadline_days | -0.616689 | 0.616689 |
| 8 | core_sales_segment | opportunity_type | 0.584847 | 0.584847 |
| 9 | product_status | target | 0.564560 | 0.564560 |
| 10 | core_product_application | core_product_segment | 0.529854 | 0.529854 |
| 11 | core_consumption_market | core_sales_segment | 0.475922 | 0.475922 |
| 12 | product_status | remaining_deadline_days | -0.403247 | 0.403247 |
| 13 | core_consumption_market | opportunity_type | 0.392051 | 0.392051 |
| 14 | decision_time_days | product_status | -0.366615 | 0.366615 |
| 15 | core_sales_segment | product_quantity | -0.357633 | 0.357633 |
| 16 | core_product_segment | core_sales_segment | 0.352987 | 0.352987 |
| 17 | core_product_application | core_sales_segment | 0.340883 | 0.340883 |
| 18 | remaining_deadline_days | transition_from_stage_name | -0.337468 | 0.337468 |
| 19 | opportunity_type | product_quantity | -0.322033 | 0.322033 |
| 20 | remaining_deadline_days | transition_to_stage | -0.316596 | 0.316596 |
| 21 | decision_time_days | transition_to_stage | -0.306591 | 0.306591 |
| 22 | decision_time_days | target | -0.298647 | 0.298647 |
| 23 | decision_time_days | transition_from_stage_name | -0.288902 | 0.288902 |
| 24 | core_product_segment | product_quantity | -0.280139 | 0.280139 |
| 25 | opportunity_type | product_$ | -0.268303 | 0.268303 |
| 26 | remaining_deadline_days | target | -0.247363 | 0.247363 |
| 27 | core_product_application | target | 0.243423 | 0.243423 |
| 28 | core_consumption_market | product_quantity | -0.239498 | 0.239498 |
| 29 | core_consumption_market | geography | 0.237104 | 0.237104 |
| 30 | core_sales_segment | product_$ | -0.231463 | 0.231463 |
| 31 | core_consumption_market | core_product_segment | 0.215766 | 0.215766 |
| 32 | core_consumption_market | core_product_application | 0.214955 | 0.214955 |
| 33 | geography | opportunity_type | 0.210935 | 0.210935 |
| 34 | decision_time_days | opportunity_type | -0.200365 | 0.200365 |
| 35 | decision_time_days | product_quantity | 0.197021 | 0.197021 |
| 36 | core_consumption_market | product_$ | -0.187064 | 0.187064 |
| 37 | core_sales_segment | target | 0.185509 | 0.185509 |
| 38 | decision_time_days | product_$ | 0.185211 | 0.185211 |
| 39 | core_product_application | transition_from_stage_name | 0.184546 | 0.184546 |
| 40 | core_product_application | transition_to_stage | 0.184078 | 0.184078 |
| 41 | decision_time_days | progression_time_days | 0.180723 | 0.180723 |
| 42 | no_of_products | product_$ | 0.175762 | 0.175762 |
| 43 | core_product_application | product_quantity | -0.174389 | 0.174389 |
| 44 | core_sales_segment | transition_to_stage | 0.171385 | 0.171385 |
| 45 | core_sales_segment | transition_from_stage_name | 0.165471 | 0.165471 |
| 46 | core_sales_segment | decision_time_days | -0.157233 | 0.157233 |
| 47 | core_consumption_market | target | 0.155978 | 0.155978 |
| 48 | core_sales_segment | geography | 0.155451 | 0.155451 |
| 49 | product_status | progression_time_days | 0.151422 | 0.151422 |
| 50 | core_product_application | product_status | 0.150267 | 0.150267 |
| 51 | progression_time_days | transition_from_stage_name | 0.144523 | 0.144523 |
| 52 | core_product_segment | target | 0.143751 | 0.143751 |
| 53 | progression_time_days | transition_time | -0.141629 | 0.141629 |
| 54 | geography | product_status | 0.139968 | 0.139968 |
| 55 | core_product_application | opportunity_type | 0.139647 | 0.139647 |
| 56 | opportunity_type | transition_to_stage | 0.132636 | 0.132636 |
| 57 | geography | product_$ | -0.132413 | 0.132413 |
| 58 | core_sales_segment | product_status | 0.132352 | 0.132352 |
| 59 | geography | product_quantity | -0.128608 | 0.128608 |
| 60 | core_product_segment | decision_time_days | -0.128505 | 0.128505 |
| 61 | core_product_segment | opportunity_type | 0.127521 | 0.127521 |
| 62 | core_consumption_market | transition_to_stage | 0.126448 | 0.126448 |
| 63 | opportunity_type | transition_from_stage_name | 0.125606 | 0.125606 |
| 64 | core_product_application | remaining_deadline_days | -0.124770 | 0.124770 |
| 65 | core_consumption_market | transition_from_stage_name | 0.124525 | 0.124525 |
| 66 | core_product_application | decision_time_days | -0.123600 | 0.123600 |
| 67 | product_quantity | remaining_deadline_days | 0.121416 | 0.121416 |
| 68 | opportunity_type | target | 0.116346 | 0.116346 |
| 69 | geography | transition_from_stage_name | 0.115822 | 0.115822 |
| 70 | opportunity_type | progression_time_days | -0.113899 | 0.113899 |
| 71 | geography | transition_to_stage | 0.112317 | 0.112317 |
| 72 | geography | target | 0.112064 | 0.112064 |
| 73 | core_product_segment | transition_from_stage_name | 0.109795 | 0.109795 |
| 74 | decision_time_days | geography | -0.108692 | 0.108692 |
| 75 | core_product_segment | remaining_deadline_days | -0.106181 | 0.106181 |
| 76 | core_product_segment | transition_to_stage | 0.105572 | 0.105572 |
| 77 | opportunity_type | product_status | 0.104619 | 0.104619 |
| 78 | product_$ | remaining_deadline_days | 0.103175 | 0.103175 |
| 79 | core_product_segment | product_$ | -0.101267 | 0.101267 |
| 80 | progression_time_days | transition_to_stage | 0.101157 | 0.101157 |
| 81 | geography | remaining_deadline_days | -0.100176 | 0.100176 |
| 82 | core_consumption_market | product_status | 0.099132 | 0.099132 |
| 83 | no_of_products | target | 0.099103 | 0.099103 |
| 84 | core_sales_segment | remaining_deadline_days | -0.097598 | 0.097598 |
| 85 | product_$ | product_status | -0.096452 | 0.096452 |
| 86 | no_of_products | transition_to_stage | 0.094410 | 0.094410 |
| 87 | core_consumption_market | decision_time_days | -0.092558 | 0.092558 |
| 88 | no_of_products | transition_from_stage_name | 0.092375 | 0.092375 |
| 89 | opportunity_type | transition_time | 0.089202 | 0.089202 |
| 90 | product_quantity | product_status | -0.087286 | 0.087286 |
| 91 | core_product_segment | product_status | 0.081988 | 0.081988 |
| 92 | product_quantity | target | -0.076781 | 0.076781 |
| 93 | product_quantity | transition_to_stage | -0.074528 | 0.074528 |
| 94 | no_of_products | product_quantity | 0.071514 | 0.071514 |
| 95 | product_quantity | transition_from_stage_name | -0.071260 | 0.071260 |
| 96 | opportunity_type | remaining_deadline_days | -0.066898 | 0.066898 |
| 97 | remaining_deadline_days | transition_time | 0.064931 | 0.064931 |
| 98 | core_consumption_market | remaining_deadline_days | -0.059137 | 0.059137 |
| 99 | no_of_products | product_status | -0.057250 | 0.057250 |
| 100 | transition_from_stage_name | transition_time | 0.057128 | 0.057128 |
| 101 | core_product_segment | geography | 0.053871 | 0.053871 |
| 102 | core_sales_segment | no_of_products | 0.053405 | 0.053405 |
| 103 | decision_time_days | transition_time | -0.052826 | 0.052826 |
| 104 | product_$ | progression_time_days | 0.048929 | 0.048929 |
| 105 | core_product_application | no_of_products | 0.048017 | 0.048017 |
| 106 | core_product_application | geography | 0.046010 | 0.046010 |
| 107 | geography | transition_time | 0.045380 | 0.045380 |
| 108 | product_quantity | progression_time_days | 0.040132 | 0.040132 |
| 109 | transition_time | transition_to_stage | 0.038315 | 0.038315 |
| 110 | core_product_application | progression_time_days | 0.036170 | 0.036170 |
| 111 | core_consumption_market | no_of_products | 0.033555 | 0.033555 |
| 112 | no_of_products | remaining_deadline_days | -0.030874 | 0.030874 |
| 113 | no_of_products | progression_time_days | 0.028570 | 0.028570 |
| 114 | core_consumption_market | transition_time | 0.028145 | 0.028145 |
| 115 | product_$ | transition_to_stage | -0.027739 | 0.027739 |
| 116 | no_of_products | transition_time | -0.026519 | 0.026519 |
| 117 | core_sales_segment | progression_time_days | -0.024318 | 0.024318 |
| 118 | geography | progression_time_days | 0.024255 | 0.024255 |
| 119 | product_$ | transition_time | -0.024197 | 0.024197 |
| 120 | core_sales_segment | transition_time | 0.023354 | 0.023354 |
| 121 | product_$ | transition_from_stage_name | -0.023011 | 0.023011 |
| 122 | product_$ | target | -0.022808 | 0.022808 |
| 123 | product_quantity | transition_time | -0.021852 | 0.021852 |
| 124 | geography | no_of_products | -0.020277 | 0.020277 |
| 125 | core_product_segment | no_of_products | 0.019092 | 0.019092 |
| 126 | core_product_application | transition_time | 0.018717 | 0.018717 |
| 127 | target | transition_time | 0.017899 | 0.017899 |
| 128 | no_of_products | opportunity_type | 0.014313 | 0.014313 |
| 129 | progression_time_days | target | 0.011653 | 0.011653 |
| 130 | core_consumption_market | progression_time_days | -0.011188 | 0.011188 |
| 131 | product_status | transition_time | 0.008815 | 0.008815 |
| 132 | core_product_segment | progression_time_days | 0.008794 | 0.008794 |
| 133 | decision_time_days | no_of_products | -0.008547 | 0.008547 |
| 134 | core_product_segment | transition_time | 0.003953 | 0.003953 |
| 135 | core_product_application | product_$ | -0.001629 | 0.001629 |